Computer Science for IGCSE & O level - Databases (Section 4 - No. 46)
What is the purpose of an index in a database?
To enforce data validation rules.
To speed up data retrieval.
To store the actual data.
To define relationships between tables.
Paliwanag
An index improves query performance by providing a quick lookup path for data based on specific columns.